package popcorn.ticket.dao;

import java.util.List;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import popcorn.ticket.entity.Orders;
import popcorn.ticket.entity.OrdersExample;
@Repository
public interface OrdersMapper {
    long countByExample(OrdersExample example);

    int deleteByExample(OrdersExample example);

    int deleteByPrimaryKey(Integer orderid);

    int insert(Orders record);

    int insertSelective(Orders record);

    List<Orders> selectByExample(OrdersExample example);

    Orders selectByPrimaryKey(Integer orderid);

    int updateByExampleSelective(@Param("record") Orders record, @Param("example") OrdersExample example);

    int updateByExample(@Param("record") Orders record, @Param("example") OrdersExample example);

    int updateByPrimaryKeySelective(Orders record);

    int updateByPrimaryKey(Orders record);
    
    //通过用户名模糊查询
    List<Orders> selectByUserName(String moviename,String username,@Param("startdate")String startdate,@Param("enddate")String enddate,@Param("selstatus")int selstatus);
    
    //查找数据库是否存在该座位
    int selectSeatCount(String seat);
    
    //后台首页显示的一周金额
    List<Orders> sltPriceList();
    //获取当天得到的金额
    Orders sltManeyNowNum();
    
    //通过用户编号查询订单列表
    List<Orders> selectByUserId(int userid);
    
    
}